package com.uzhie.web.dao;

import com.uzhie.web.module.GpsRecord;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.session.RowBounds;
import tk.mybatis.mapper.common.Mapper;
import tk.mybatis.mapper.common.MySqlMapper;

import java.util.List;

/**
 * Created by lilongfei on 2018/8/1.
 */
public interface GpsDAO extends Mapper<GpsRecord>,MySqlMapper<GpsRecord> {

    /**
     * 通过设备内置sim卡查询车辆位置信息
     * @param simNumber
     * @return
     */
    GpsRecord queryListBySIM(@Param("sim") String simNumber);

    int insertGroup(@Param("list") List<GpsRecord> gpsRecords);

//    GpsRecord queryLastPositionByNumber(@Param("vehicleNumber") String vehicleNumber);.
   List<GpsRecord> queryDayTrajectoryByVehicleNumber(@Param("vehicleNumber")  String vehicleNumber, @Param("day")  String day);
}
